package com.its.us.web.mapper.sys;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.its.us.web.entity.sys.Role;
import com.its.us.web.entity.sys.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @className UserMapper
 * @author huguangjun
 * @date 2020/12/3
 * @desc 9:05
 */
public interface UserMapper extends BaseMapper<User> {

//    @Select("select * from sys_user")
//    @Results(id = "userMap", value = {
//            @Result(id = true, column = "id", property = "id"),
//            @Result(column = "username", property = "username"),
//            @Result(column = "password", property = "password"),
//    })
//    List<User> findUserList();

    //@Select("select id,username,password from sys_user where username=#{username}")
    //User getUserByName(String username);

    @Select("select id,username from sys_user where username=#{username}")
    User getUserByNameNotPassword(String username);

    List<User> getTestUserList();

}
